QC Results

Event QC

Check there is Seedling Data for all Events
Check there is Tree Data for all Events

Tree QC

Check for Duplicate Tree Tags
Check for Missing Tree Tags
No errors
Check that all the Stem Letters are Letters
No errors
Check if Cause of Death is missing or a non-Valid Cause of Death
Check if Height is Missing or Three Standard Deviations Greater than Median
Check Height Difference

Check for Trees that have a height change greater than 33% between visits

Check if DBH is Missing or Three Standard Deviations Greater than Median
Check DBH Difference

Check for Trees that have a DBH change greater than 33% between visits

Check for Recently Dead PIAL Trees with a Null Mortality Year
Check Cone Count

Return list of trees where female cones exist but there is no cone count or where female cones do not exist but cone count is populated

Check Crown Health

Return list of trees who’s crown health isn’t a domain value or live PIAL trees with missing crown health

Check Lower Crown Kill

Return a list of trees whose lower crown kill is more than 100% or alive PIAL trees that have a null lower crown kill but are not null in both upper and middle crown kill percents

Check Middle Crown Kill

Return a list of trees whose middle crown kill is more than 100% or live PIAL trees that have a null middle crown kill but are not null in both upper and lower crown kill percents

No errors
Check Upper Crown Kill

Return a list of trees whose upper crown kill is more than 100% or live PIAL trees that have a null upper crown kill but are not null in both middle and lower crown kill percents

Check Subplot Numbers are between 1 and 5
No errors
Check if Vitality is Missing or a non-Valid Domain Value
Check Lower Bole Cankers

Return a list of trees with non-valid responses in the lower bole canker columns

Check Middle Bole Cankers

Return a list of trees with non-valid responses in the middle bole canker columns

Check Upper Bole Cankers

Return a list of trees with non-valid responses in the upper bole canker columns

Check Lower Branch Cankers

Return a list of trees with non-valid responses in the lower branch canker columns

Check Middle Branch Cankers

Return a list of trees with non-valid responses in the middle branch canker columns

Check Upper Branch Cankers

Return a list of trees with non-valid responses in the upper branch canker columns

Check Species

Return list of trees with missing or blank scientific names

Check that Trees aren’t listed as Recently Dead Twice

Seedling QC

Check for Plots that do not have 9 Subplots
Check Subplot Numbers are between 1 and 9
No errors
Check for Missing Tags
Check for Duplicated Tags
Check that Cause of Death is a Valid Domain Value
Check that Vitality is a Valid Domain Value
Check Species

Return list of trees with missing or blank scientific names

Check Height Classes

Return a list of seedlings that are alive but the height class does not match domain values

Check that Seedlings aren’t listed as Recently Dead Twice